package com.framework.utils;

import com.framework.entity.ColumnEntity;
import com.framework.entity.TableEntity;
import org.apache.commons.configuration.Configuration;
import org.apache.commons.configuration.ConfigurationException;
import org.apache.commons.configuration.PropertiesConfiguration;
import org.apache.commons.io.FileUtils;
import org.apache.commons.io.IOUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.lang.WordUtils;
import org.apache.velocity.Template;
import org.apache.velocity.VelocityContext;
import org.apache.velocity.app.Velocity;
import org.mybatis.generator.api.MyBatisGenerator;
import org.mybatis.generator.config.xml.ConfigurationParser;
import org.mybatis.generator.internal.DefaultShellCallback;

import java.io.*;
import java.util.*;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

/**
 * 代码生成器 工具类
 */
public class GenUtils {

    public static List<String> getTemplates() {
        List<String> templates = new ArrayList<String>();
        templates.add("template/DO.java.vm");
        templates.add("template/DTO.java.vm");
        templates.add("template/copier.java.vm");
        templates.add("template/Service.java.vm");
        templates.add("template/ServiceImpl.java.vm");
        templates.add("template/Controller.java.vm");
        /*templates.add("template/list.html.vm");
        templates.add("template/list.js.vm");
        templates.add("template/menu.sql.vm");
        templates.add("template/DOMapper.java.vm");
        templates.add("template/DOMapper.xml.vm");*/
        return templates;
    }

    /**
     * 生成代码
     */
    public static void generatorCode(Map<String, String> table, List<Map<String, String>> columns, ZipOutputStream zip) {
        // 配置信息
        Configuration config = getConfig();
        boolean hasBigDecimal = false;
        // 表信息
        TableEntity tableEntity = new TableEntity();
        tableEntity.setTableName(table.get("tableName"));
        tableEntity.setComments(table.get("tableComment"));
        // 表名转换成Java类名
        String className = tableToJava(tableEntity.getTableName(), config.getString("tablePrefix"));
        tableEntity.setClassName(className);
        tableEntity.setClassname(StringUtils.uncapitalize(className));

        // 列信息
        List<ColumnEntity> columsList = new ArrayList<>();
        for (Map<String, String> column : columns) {
            ColumnEntity columnEntity = new ColumnEntity();
            columnEntity.setColumnName(column.get("columnName"));
            columnEntity.setDataType(column.get("dataType"));
            columnEntity.setComments(column.get("columnComment"));
            columnEntity.setExtra(column.get("extra"));

            // 列名转换成Java属性名
            String attrName = columnToJava(columnEntity.getColumnName());
            columnEntity.setAttrName(attrName);
            columnEntity.setAttrname(StringUtils.uncapitalize(attrName));

            // 列的数据类型，转换成Java类型
            String attrType = config.getString(columnEntity.getDataType(), "unknowType");
            columnEntity.setAttrType(attrType);
            if (!hasBigDecimal && attrType.equals("BigDecimal")) {
                hasBigDecimal = true;
            }
            // 是否主键
            if ("PRI".equalsIgnoreCase(column.get("columnKey")) && tableEntity.getPk() == null) {
                tableEntity.setPk(columnEntity);
            }

            columsList.add(columnEntity);
        }
        tableEntity.setColumns(columsList);

        // 没主键，则第一个字段为主键
        if (tableEntity.getPk() == null) {
            tableEntity.setPk(tableEntity.getColumns().get(0));
        }

        // 设置velocity资源加载器
        Properties prop = new Properties();
        prop.put("file.resource.loader.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader");
        Velocity.init(prop);

        String mainPath = config.getString("mainPath");
        mainPath = StringUtils.isBlank(mainPath) ? "com.framework" : mainPath;

        // 封装模板数据
        Map<String, Object> map = new HashMap<>();
        map.put("tableName", tableEntity.getTableName());
        map.put("comments", tableEntity.getComments());
        map.put("pk", tableEntity.getPk());
        map.put("className", tableEntity.getClassName());
        map.put("classname", tableEntity.getClassname());
        map.put("pathName", tableEntity.getClassname().toLowerCase());
        map.put("columns", tableEntity.getColumns());
        map.put("hasBigDecimal", hasBigDecimal);
        map.put("mainPath", mainPath);
        map.put("package", config.getString("package"));
        map.put("moduleName", config.getString("moduleName"));
        map.put("author", config.getString("author"));
        map.put("email", config.getString("email"));
        map.put("datetime", DateUtils.format(new Date(), DateUtils.DATE_TIME_PATTERN));
        VelocityContext context = new VelocityContext(map);

        // 获取模板列表
        List<String> templates = getTemplates();
        for (String template : templates) {
            // 渲染模板
            StringWriter sw = new StringWriter();
            Template tpl = Velocity.getTemplate(template, "UTF-8");
            tpl.merge(context, sw);

            try {
                // 添加到zip
                zip.putNextEntry(new ZipEntry(getFileName(template, tableEntity.getClassName(), config.getString("package"), config.getString("moduleName"))));
                System.out.println(getFileName(template, tableEntity.getClassName(), config.getString("package"), config.getString("moduleName")));
                IOUtils.write(sw.toString(), zip, "UTF-8");
                IOUtils.closeQuietly(sw);

            } catch (IOException e) {
                throw new RRException("渲染模板失败，表名：" + tableEntity.getTableName(), e);
            }
        }


    }

    public static void generator(String database,String tableNames, String domainObjectNames, ZipOutputStream zip) {
        try {
            System.out.println(tableNames + "--" + domainObjectNames);
            Dom4JXML.DOM$J(database,tableNames, domainObjectNames);
            List<String> warnings = new ArrayList<String>();
            boolean overwrite = true;
            // 指定配置文件
            File configFile = new File("E:\\MyProject\\universal-framework\\framework-generator\\src\\main\\resources\\generatorConfig.xml");
            ConfigurationParser cp = new ConfigurationParser(warnings);
            org.mybatis.generator.config.Configuration config = cp.parseConfiguration(configFile);
            DefaultShellCallback callback = new DefaultShellCallback(overwrite);
            MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
            myBatisGenerator.generate(null);
            Map<String, File> file = new HashMap<>();
            file.put(domainObjectNames + "Mapper.java", new File("E:\\MyProject\\universal-framework\\framework-generator\\src\\main\\resources\\generator\\com\\hangshutech\\core\\mapper\\" + domainObjectNames + "Mapper.java"));
            file.put(domainObjectNames + "Mapper.xml", new File("E:\\MyProject\\universal-framework\\framework-generator\\src\\main\\resources\\generator\\com\\hangshutech\\core\\mapper\\" + domainObjectNames + "Mapper.xml"));
            mergeToZip(file, zip);

        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    //打包成为ZIP文件
    public static void mergeToZip(Map<String, File> fileMap, ZipOutputStream zip) {
        //合并输出为一个压缩包
        try {

            Iterator<Map.Entry<String, File>> set = fileMap.entrySet().iterator();
            while (set.hasNext()) {
                Map.Entry<String, File> entry = set.next();
                File file = entry.getValue();
                ZipEntry zipEntry = new ZipEntry(entry.getKey());
                zipEntry.setSize(file.length());
                zip.putNextEntry(zipEntry);
                FileInputStream in = new FileInputStream(file);
                IOUtils.copy(in, zip);
                IOUtils.closeQuietly(in);
                FileUtils.deleteQuietly(file);
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    /**
     * 列名转换成Java属性名
     */
    public static String columnToJava(String columnName) {
        return WordUtils.capitalizeFully(columnName, new char[]{'_'}).replace("_", "");
    }

    /**
     * 表名转换成Java类名
     */
    public static String tableToJava(String tableName, String tablePrefix) {
        if (StringUtils.isNotBlank(tablePrefix)) {
            tableName = tableName.replace(tablePrefix, "");
        }
        return columnToJava(tableName);
    }

    /**
     * 获取配置信息
     */
    public static Configuration getConfig() {
        try {
            PropertiesConfiguration propertiesConfiguration = new PropertiesConfiguration("generator.properties");
            propertiesConfiguration.setEncoding("UTF-8");
            return propertiesConfiguration;
        } catch (ConfigurationException e) {
            throw new RRException("获取配置文件失败，", e);
        }
    }

    /**
     * 获取文件名
     */
    public static String getFileName(String template, String className, String packageName, String moduleName) {
        String packagePath = "main" + File.separator + "java" + File.separator;
        if (StringUtils.isNotBlank(packageName)) {
            packagePath += packageName.replace(".", File.separator) + File.separator + File.separator;
        }

        if (template.contains("DO.java.vm")) {
            return "domain\\" + className + "DO.java";
        }

        if (template.contains("copier.java.vm")) {
            return "domain\\Copier\\" + className + "DTO2DOCopier.java";
        }

        if (template.contains("DTO.java.vm")) {
            return "domain\\dto\\" + className + "DTO.java";
        }

        if (template.contains("Service.java.vm")) {
            return "Service\\" + className + "Service.java";
        }

        if (template.contains("ServiceImpl.java.vm")) {
            return "Service\\impl\\" + className + "ServiceImpl.java";
        }

        if (template.contains("Controller.java.vm")) {
            return "controller\\"+className + "Ctrl.java";
        }

        if (template.contains("DOMapper.xml.vm")) {
            return packagePath + "ALL" + File.separator + className + "DOMapper.xml";
        }

        if (template.contains("DOMapper.java.vm")) {
            return packagePath + "ALL" + File.separator + className + "DOMapper.java";
        }

        if (template.contains("list.html.vm")) {
            return "main" + File.separator + "resources" + File.separator + "templates" + File.separator + "modules" + File.separator + moduleName + File.separator + className.toLowerCase() + ".html";
        }

        if (template.contains("list.js.vm")) {
            return "main" + File.separator + "resources" + File.separator + "statics" + File.separator + "js" + File.separator + "modules" + File.separator + moduleName + File.separator + className.toLowerCase() + ".js";
        }

        if (template.contains("menu.sql.vm")) {
            return className.toLowerCase() + "_menu.sql";
        }

        return null;
    }
}
